--DROP TABLE SkillsCourseStudentAnswer
--DROP TABLE SkillsStudentAnswer
--DROP TABLE SkillsQuestion
--DROP TABLE SkillsCourseQuestion
--DROP TABLE SkillsAnswer
--DROP TABLE SkillsPeriod
--DROP TABLE SkillsAnswerType



SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO

IF NOT EXISTS (SELECT * FROM sysobjects WHERE name = 'SkillsAnswerType' and type = 'U')
BEGIN

	CREATE TABLE [SkillsAnswerType](
		[ID] [int] IDENTITY(1,1) NOT NULL,
		[Description] [varchar](512) NOT NULL,
		[OrderBy] [int] NOT NULL,
		[IsObsolete] [bit] NOT NULL,
	 CONSTRAINT [PK_SkillsAnswerType] PRIMARY KEY CLUSTERED 
	(
		[ID] ASC
	) ON [PRIMARY],
	 CONSTRAINT [UQ_SkillsAnswerType] UNIQUE NONCLUSTERED 
	(
		[Description] ASC
	) ON [PRIMARY]
	) ON [PRIMARY]

	ALTER TABLE [SkillsAnswerType] ADD  CONSTRAINT [DF_SkillsAnswerType_IsObsolete]  DEFAULT ((0)) FOR [IsObsolete]

END


GO
SET ANSI_PADDING OFF
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO

IF NOT EXISTS (SELECT * FROM sysobjects WHERE name = 'SkillsQuestion' and type = 'U')
BEGIN

	CREATE TABLE [SkillsQuestion](
		[ID] [int] IDENTITY(1,1) NOT NULL,
		[SkillsAnswerTypeID] [int] NOT NULL,
		[Description] [varchar](512) NOT NULL,
		[OrderBy] [int] NOT NULL,
		[IsObsolete] [bit] NOT NULL,
	 CONSTRAINT [PK_SkillsQuestion] PRIMARY KEY CLUSTERED 
	(
		[ID] ASC
	) ON [PRIMARY],
	 CONSTRAINT [UQ_SkillsQuestion] UNIQUE NONCLUSTERED 
	(
		[Description] ASC
	) ON [PRIMARY]
	) ON [PRIMARY]

	ALTER TABLE [SkillsQuestion] ADD  CONSTRAINT [DF_SkillsQuestion_IsObsolete]  DEFAULT ((0)) FOR [IsObsolete]

	ALTER TABLE [SkillsQuestion]  WITH CHECK ADD  CONSTRAINT [FK_SkillsQuestion_SkillsAnswerType] FOREIGN KEY([SkillsAnswerTypeID])
	REFERENCES [SkillsAnswerType] ([ID])

	ALTER TABLE [SkillsQuestion] CHECK CONSTRAINT [FK_SkillsQuestion_SkillsAnswerType]

END

GO
SET ANSI_PADDING OFF
GO


SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO

IF NOT EXISTS (SELECT * FROM sysobjects WHERE name = 'SkillsCourseQuestion' and type = 'U')
BEGIN

	CREATE TABLE [SkillsCourseQuestion](
		[ID] [int] IDENTITY(1,1) NOT NULL,
		[SkillsAnswerTypeID] [int] NOT NULL,
		[CourseID] [int] NOT NULL,
		[Description] [varchar](512) NOT NULL,
		[OrderBy] [int] NOT NULL,
		[IsObsolete] [bit] NOT NULL,
	 CONSTRAINT [PK_SkillsCourseQuestion] PRIMARY KEY CLUSTERED 
	(
		[ID] ASC
	) ON [PRIMARY],
	 CONSTRAINT [UQ_SkillsCourseQuestion] UNIQUE NONCLUSTERED 
	(
		[CourseID] ASC,
		[Description] ASC
	) ON [PRIMARY]
	) ON [PRIMARY]

	ALTER TABLE [SkillsCourseQuestion] ADD  CONSTRAINT [DF_SkillsCourseQuestion_IsObsolete]  DEFAULT ((0)) FOR [IsObsolete]

	ALTER TABLE [SkillsCourseQuestion]  WITH CHECK ADD  CONSTRAINT [FK_SkillsCourseQuestion_Course] FOREIGN KEY([CourseID])
	REFERENCES [Course] ([ID])

	ALTER TABLE [SkillsCourseQuestion] CHECK CONSTRAINT [FK_SkillsCourseQuestion_Course]

	ALTER TABLE [SkillsCourseQuestion]  WITH CHECK ADD  CONSTRAINT [FK_SkillsCourseQuestion_SkillsAnswerType] FOREIGN KEY([SkillsAnswerTypeID])
	REFERENCES [SkillsAnswerType] ([ID])

	ALTER TABLE [SkillsCourseQuestion] CHECK CONSTRAINT [FK_SkillsCourseQuestion_SkillsAnswerType]

END


GO
SET ANSI_PADDING OFF
GO


SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO

IF NOT EXISTS (SELECT * FROM sysobjects WHERE name = 'SkillsAnswer' and type = 'U')
BEGIN

	CREATE TABLE [SkillsAnswer](
		[ID] [int] IDENTITY(1,1) NOT NULL,
		[SkillsAnswerTypeID] [int] NOT NULL,
		[Description] [varchar](100) NOT NULL,
		[Value] [int] NOT NULL,
		[OrderBy] [int] NOT NULL,
		[IsObsolete] [bit] NOT NULL,
	 CONSTRAINT [PK_SkillsAnswer] PRIMARY KEY CLUSTERED 
	(
		[ID] ASC
	) ON [PRIMARY],
	 CONSTRAINT [UQ_SkillsAnswer] UNIQUE NONCLUSTERED 
	(
		[SkillsAnswerTypeID] ASC,
		[Description] ASC
	) ON [PRIMARY]
	) ON [PRIMARY]

	ALTER TABLE [SkillsAnswer] ADD  CONSTRAINT [DF_SkillsAnswer_IsObsolete]  DEFAULT ((0)) FOR [IsObsolete]

	ALTER TABLE [SkillsAnswer]  WITH CHECK ADD  CONSTRAINT [FK_SkillsAnswer_SkillsAnswerType] FOREIGN KEY([SkillsAnswerTypeID])
	REFERENCES [SkillsAnswerType] ([ID])

	ALTER TABLE [SkillsAnswer] CHECK CONSTRAINT [FK_SkillsAnswer_SkillsAnswerType]

END

GO
SET ANSI_PADDING OFF
GO


SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO

IF NOT EXISTS (SELECT * FROM sysobjects WHERE name = 'SkillsPeriod' and type = 'U')
BEGIN

	CREATE TABLE [SkillsPeriod](
		[ID] [int] IDENTITY(1,1) NOT NULL,
		[AcademicYearID] [varchar](5) NOT NULL,
		[DefaultDescription] [varchar](100) NOT NULL,
		[SkillsPeriodDescription] [varchar](100) NULL,
		[OrderBy] [int] NOT NULL,
		[ShowByDefaultOpenDate] [Datetime] NOT NULL,
		[ShowByDefaultCloseDate] [Datetime] NOT NULL,
		[IsEditable] [bit] NOT NULL,
	 CONSTRAINT [PK_SkillsPeriod] PRIMARY KEY CLUSTERED 
	(
		[ID] ASC
	) ON [PRIMARY],
	 CONSTRAINT [UQ_SkillsPeriod] UNIQUE NONCLUSTERED 
	(
		[AcademicYearID] ASC,
		[DefaultDescription] ASC
	) ON [PRIMARY]
	) ON [PRIMARY]

	ALTER TABLE [SkillsPeriod] ADD  CONSTRAINT [DF_SkillsPeriod_IsEditable]  DEFAULT ((0)) FOR [IsEditable]

END

GO
SET ANSI_PADDING OFF
GO



SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO

IF NOT EXISTS (SELECT * FROM sysobjects WHERE name = 'SkillsStudentAnswer' and type = 'U')
BEGIN

	CREATE TABLE [SkillsStudentAnswer](
		[ID] [int] IDENTITY(1,1) NOT NULL,
		[OGP_StudentID] [int] NOT NULL,
		[SkillsPeriodID] [int] NOT NULL,
		[SkillsQuestionID] [int] NOT NULL,
		[SkillsAnswerID] [int] NOT NULL,
		[AnswerText] [varchar](512) NULL,
	 CONSTRAINT [PK_SkillsStudentAnswer] PRIMARY KEY CLUSTERED 
	(
		[ID] ASC
	) ON [PRIMARY],
	 CONSTRAINT [UQ_SkillsStudentAnswer] UNIQUE NONCLUSTERED 
	(
		[OGP_StudentID] ASC,
		[SkillsPeriodID] ASC,
		[SkillsQuestionID] ASC
	) ON [PRIMARY]
	) ON [PRIMARY]

	ALTER TABLE [SkillsStudentAnswer]  WITH CHECK ADD  CONSTRAINT [FK_SkillsStudentAnswer_OGP_Student] FOREIGN KEY([OGP_StudentID])
	REFERENCES [OGP_Student] ([ID])
	ALTER TABLE [SkillsStudentAnswer] CHECK CONSTRAINT [FK_SkillsStudentAnswer_OGP_Student]

	ALTER TABLE [SkillsStudentAnswer]  WITH CHECK ADD  CONSTRAINT [FK_SkillsStudentAnswer_SkillsPeriod] FOREIGN KEY([SkillsPeriodID])
	REFERENCES [SkillsPeriod] ([ID])
	ALTER TABLE [SkillsStudentAnswer] CHECK CONSTRAINT [FK_SkillsStudentAnswer_SkillsPeriod]

	ALTER TABLE [SkillsStudentAnswer]  WITH CHECK ADD  CONSTRAINT [FK_SkillsStudentAnswer_SkillsQuestion] FOREIGN KEY([SkillsQuestionID])
	REFERENCES [SkillsQuestion] ([ID])
	ALTER TABLE [SkillsStudentAnswer] CHECK CONSTRAINT [FK_SkillsStudentAnswer_SkillsQuestion]

	ALTER TABLE [SkillsStudentAnswer]  WITH CHECK ADD  CONSTRAINT [FK_SkillsStudentAnswer_SkillsAnswer] FOREIGN KEY([SkillsAnswerID])
	REFERENCES [SkillsAnswer] ([ID])
	ALTER TABLE [SkillsStudentAnswer] CHECK CONSTRAINT [FK_SkillsStudentAnswer_SkillsAnswer]

END

GO
SET ANSI_PADDING OFF
GO


SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO

IF NOT EXISTS (SELECT * FROM sysobjects WHERE name = 'SkillsCourseStudentAnswer' and type = 'U')
BEGIN

	CREATE TABLE [SkillsCourseStudentAnswer](
		[ID] [int] IDENTITY(1,1) NOT NULL,
		[CourseID] [int] NOT NULL,
		[OGP_StudentID] [int] NOT NULL,
		[SkillsPeriodID] [int] NOT NULL,
		[SkillsCourseQuestionID] [int] NOT NULL,
		[SkillsAnswerID] [int] NOT NULL,
		[AnswerText] [varchar](512) NULL,
	 CONSTRAINT [PK_SkillsCourseStudentAnswer] PRIMARY KEY CLUSTERED 
	(
		[ID] ASC
	) ON [PRIMARY],
	 CONSTRAINT [UQ_SkillsCourseStudentAnswer] UNIQUE NONCLUSTERED 
	(
		[CourseID] ASC, 
		[OGP_StudentID] ASC,
		[SkillsPeriodID] ASC,
		[SkillsCourseQuestionID] ASC
	) ON [PRIMARY]
	) ON [PRIMARY]

	ALTER TABLE [SkillsCourseStudentAnswer]  WITH CHECK ADD  CONSTRAINT [FK_SkillsCourseStudentAnswer_Course] FOREIGN KEY([CourseID])
	REFERENCES [Course] ([ID])
	ALTER TABLE [SkillsCourseStudentAnswer] CHECK CONSTRAINT [FK_SkillsCourseStudentAnswer_Course]

	ALTER TABLE [SkillsCourseStudentAnswer]  WITH CHECK ADD  CONSTRAINT [FK_SkillsCourseStudentAnswer_OGP_Student] FOREIGN KEY([OGP_StudentID])
	REFERENCES [OGP_Student] ([ID])
	ALTER TABLE [SkillsCourseStudentAnswer] CHECK CONSTRAINT [FK_SkillsCourseStudentAnswer_OGP_Student]

	ALTER TABLE [SkillsCourseStudentAnswer]  WITH CHECK ADD  CONSTRAINT [FK_SkillsCourseStudentAnswer_SkillsPeriod] FOREIGN KEY([SkillsPeriodID])
	REFERENCES [SkillsPeriod] ([ID])
	ALTER TABLE [SkillsCourseStudentAnswer] CHECK CONSTRAINT [FK_SkillsCourseStudentAnswer_SkillsPeriod]

	ALTER TABLE [SkillsCourseStudentAnswer]  WITH CHECK ADD  CONSTRAINT [FK_SkillsCourseStudentAnswer_SkillsCourseQuestion] FOREIGN KEY([SkillsCourseQuestionID])
	REFERENCES [SkillsCourseQuestion] ([ID])
	ALTER TABLE [SkillsCourseStudentAnswer] CHECK CONSTRAINT [FK_SkillsCourseStudentAnswer_SkillsCourseQuestion]

	ALTER TABLE [SkillsCourseStudentAnswer]  WITH CHECK ADD  CONSTRAINT [FK_SkillsCourseStudentAnswer_SkillsAnswer] FOREIGN KEY([SkillsAnswerID])
	REFERENCES [SkillsAnswer] ([ID])
	ALTER TABLE [SkillsCourseStudentAnswer] CHECK CONSTRAINT [FK_SkillsCourseStudentAnswer_SkillsAnswer]

END

GO
SET ANSI_PADDING OFF
GO

IF (SELECT COUNT([ID]) FROM [SkillsPeriod]) = 0
BEGIN

	INSERT [SkillsPeriod] ([AcademicYearID], [DefaultDescription], [SkillsPeriodDescription], [OrderBy], [ShowByDefaultOpenDate], [ShowByDefaultCloseDate])
	SELECT '23/24', 'Period1', 'Initial Skills Assessment Sept 2023', 1, '20230901','20230930'
	UNION SELECT '23/24', 'Period2', 'Autumn 2023', 2, '20231001','20231231'
	UNION SELECT '23/24', 'Period3', 'Spring 2024', 3, '20240101','20240331'
	UNION SELECT '23/24', 'Period4', 'Summer 2024', 4, '20240401','20240731'
	UNION SELECT '23/24', 'Period5', NULL, 5, '20000101','20000101'
	UNION SELECT '23/24', 'Period6', NULL, 6, '20000101','20000101'
	UNION SELECT '23/24', 'Period7', NULL, 7, '20000101','20000101'
	UNION SELECT '23/24', 'Period8', NULL, 8, '20000101','20000101'
	UNION SELECT '23/24', 'Period9', NULL, 9, '20000101','20000101'
	UNION SELECT '23/24', 'Period10', NULL, 10, '20000101','20000101'
	UNION SELECT '24/25', 'Period1', 'Initial Skills Assessment Sept 2024', 1, '20240901','20240930'
	UNION SELECT '24/25', 'Period2', 'Autumn 2024', 2, '20241001','20241231'
	UNION SELECT '24/25', 'Period3', 'Spring 2025', 3, '20250101','20250331'
	UNION SELECT '24/25', 'Period4', 'Summer 2025', 4, '20250401','20250731'
	UNION SELECT '24/25', 'Period5', NULL, 5, '20000101','20000101'
	UNION SELECT '24/25', 'Period6', NULL, 6, '20000101','20000101'
	UNION SELECT '24/25', 'Period7', NULL, 7, '20000101','20000101'
	UNION SELECT '24/25', 'Period8', NULL, 8, '20000101','20000101'
	UNION SELECT '24/25', 'Period9', NULL, 9, '20000101','20000101'
	UNION SELECT '24/25', 'Period10', NULL, 10, '20000101','20000101'
	UNION SELECT '25/26', 'Period1', 'Initial Skills Assessment Sept 2025', 1, '20250901','20250930'
	UNION SELECT '25/26', 'Period2', 'Autumn 2025', 2, '20251001','20251201'
	UNION SELECT '25/26', 'Period3', 'Spring 2026', 3, '20260101','20260331'
	UNION SELECT '25/26', 'Period4', 'Summer 2026', 4, '20260401','20260731'
	UNION SELECT '25/26', 'Period5', NULL, 5, '20000101','20000101'
	UNION SELECT '25/26', 'Period6', NULL, 6, '20000101','20000101'
	UNION SELECT '25/26', 'Period7', NULL, 7, '20000101','20000101'
	UNION SELECT '25/26', 'Period8', NULL, 8, '20000101','20000101'
	UNION SELECT '25/26', 'Period9', NULL, 9, '20000101','20000101'
	UNION SELECT '25/26', 'Period10', NULL, 10, '20000101','20000101'

END
GO


IF (SELECT COUNT([ID]) FROM [SkillsAnswerType]) = 0
BEGIN

SET IDENTITY_INSERT SkillsAnswerType ON

	INSERT SkillsAnswerType(ID, Description, OrderBy)
	SELECT 1, 'Yes/No', 1
	UNION SELECT 2, 'Str.Agree - Str.Disagree (5)', 2
	UNION SELECT 3, 'Str.Agree - Str.Disagree (4)', 3
	UNION SELECT 4, 'Agree - Disagree (3)', 4
	UNION SELECT 5, 'Agree - Disagree (2)', 5
	UNION SELECT 6, '1 (Low) - 5 (High)', 6

SET IDENTITY_INSERT SkillsAnswerType OFF

END 
GO


IF (SELECT COUNT([ID]) FROM [SkillsAnswer]) = 0
BEGIN

SET IDENTITY_INSERT SkillsAnswer ON

	INSERT SkillsAnswer(ID, SkillsAnswerTypeID, Description, Value, OrderBy)

	SELECT 1, 1, 'Strongly Agree', 5, 1
	UNION SELECT 2, 1,'Agree', 4, 2
	UNION SELECT 3, 1, 'Neutral', 3, 3
	UNION SELECT 4, 1, 'Disagree', 2, 4
	UNION SELECT 5, 1, 'Strongly Disagree', 1, 5
	UNION SELECT 6, 2, 'Yes', 5, 1
	UNION SELECT 7, 2, 'No', 1, 2
	UNION SELECT 8, 3, 'Strongly Agree', 5, 1
	UNION SELECT 9, 3, 'Agree', 4, 2
	UNION SELECT 10,3, 'Disagree', 2, 4
	UNION SELECT 11,3, 'Strongly Disagree', 1, 5
	UNION SELECT 12,4, 'Agree', 5, 1
	UNION SELECT 13,4, 'Neutral', 3, 2
	UNION SELECT 14,4, 'Disagree', 1, 3
	UNION SELECT 15,5, 'Agree', 5, 1
	UNION SELECT 16,5, 'Disagree', 1, 3
	UNION SELECT 17,6, '5 Very High', 5, 1
	UNION SELECT 18,6, '4 High', 4, 2
	UNION SELECT 19,6, '3 Medium',3, 3
	UNION SELECT 20,6, '2 Low', 2, 4
	UNION SELECT 21,6, '1 Very Low', 1, 5

SET IDENTITY_INSERT SkillsAnswer OFF

END 
GO

--IF (SELECT COUNT([ID]) FROM [SkillsCourseQuestion]) = 0
--BEGIN
--	INSERT SkillsCourseQuestion (SkillsAnswerTypeID, CourseID,	Description,	OrderBy)
--	SELECT 1, 2790,	'Question1 (Course)',	1
--	UNION SELECT 1, 2790,	'Question2 (Course)',	2
--	UNION SELECT 1, 2790,	'Question3 (Course)',	3
--	UNION SELECT 1, 2790,	'Question4 (Course)',	4
--	UNION SELECT 1, 2790,	'Question5 (Course)',	5
--END
--GO

IF (SELECT COUNT([ID]) FROM [SkillsQuestion]) = 0
BEGIN
	INSERT SkillsQuestion (SkillsAnswerTypeID, Description,	OrderBy)
	SELECT 1, 'Question1',	1
	UNION SELECT 1, 'Question2',	2
	UNION SELECT 1, 'Question3',	3
	UNION SELECT 1, 'Question4',	4
	UNION SELECT 1, 'Question5',	5
END
GO


--IF (SELECT COUNT([ID]) FROM [SkillsStudentAnswer]) = 0
--BEGIN
--  INSERT SkillsStudentAnswer (OGP_StudentID, SkillsPeriodID, SkillsQuestionID, SkillsAnswerID)
--	SELECT 33826,	1,	1,	1
--	UNION SELECT 33826,	1,	2,	2
--	UNION SELECT 33826,	1,	3,	1
--	UNION SELECT 33826,	1,	5,	1
--	UNION SELECT 33826,	1,	4,	1
--	UNION SELECT 33826,	5,	1,	1
--	UNION SELECT 33826,	5,	2,	1
--	UNION SELECT 33826,	5,	3,	2
--	UNION SELECT 33826,	5,	5,	1
--	UNION SELECT 33826,	5,	4,	2
--	UNION SELECT 33826,	6,	1,	1
--	UNION SELECT 33826,	6,	2,	2
--	UNION SELECT 33826,	6,	3,	3
--	UNION SELECT 33826,	6,	5,	3
--	UNION SELECT 33826,	6,	4,	4
--	UNION SELECT 34333,	1,	1,	1
--	UNION SELECT 34333,	1,	2,	2
--	UNION SELECT 34333,	1,	3,	1
--	UNION SELECT 34333,	1,	5,	2
--	UNION SELECT 34333,	1,	4,	2
--	UNION SELECT 34333,	5,	1,	2
--	UNION SELECT 34333,	5,	2,	3
--	UNION SELECT 34333,	5,	3,	4
--	UNION SELECT 34333,	5,	5,	3
--	UNION SELECT 34333,	5,	4,	2
--	UNION SELECT 34333,	6,	1,	3
--	UNION SELECT 34333,	6,	2,	4
--	UNION SELECT 34333,	6,	3,	4
--	UNION SELECT 34333,	6,	5,	3
--	UNION SELECT 34333,	6,	4,	4
--	UNION SELECT 34764,	1,	1,	1
--	UNION SELECT 34764,	1,	2,	3
--	UNION SELECT 34764,	1,	3,	3
--	UNION SELECT 34764,	1,	5,	2
--	UNION SELECT 34764,	1,	4,	3
--	UNION SELECT 34764,	5,	1,	3
--	UNION SELECT 34764,	5,	2,	3
--	UNION SELECT 34764,	5,	3,	3
--	UNION SELECT 34764,	5,	5,	3
--	UNION SELECT 34764,	5,	4,	4
--	UNION SELECT 34764,	6,	1,	4
--	UNION SELECT 34764,	6,	2,	4
--	UNION SELECT 34764,	6,	3,	4
--	UNION SELECT 34764,	6,	5,	3
--	UNION SELECT 34764,	6,	4,	4

--END
--GO


--IF (SELECT COUNT([ID]) FROM [SkillsCourseStudentAnswer]) = 0
--BEGIN

--	INSERT SkillsCourseStudentAnswer (CourseID, OGP_StudentID, SkillsPeriodID, SkillsCourseQuestionID, SkillsAnswerID)
--	SELECT 2790,	33826,	1,	1,	1
--	UNION SELECT 2790,	33826,	1,	2,	2
--	UNION SELECT 2790,	33826,	1,	3,	1
--	UNION SELECT 2790,	33826,	1,	5,	1
--	UNION SELECT 2790,	33826,	1,	4,	2
--	UNION SELECT 2790,	33826,	5,	1,	1
--	UNION SELECT 2790,	33826,	5,	2,	1
--	UNION SELECT 2790,	33826,	5,	3,	2
--	UNION SELECT 2790,	33826,	5,	5,	1
--	UNION SELECT 2790,	33826,	5,	4,	2
--	UNION SELECT 2790,	33826,	6,	1,	1
--	UNION SELECT 2790,	33826,	6,	2,	1
--	UNION SELECT 2790,	33826,	6,	3,	1
--	UNION SELECT 2790,	33826,	6,	5,	3
--	UNION SELECT 2790,	33826,	6,	4,	2
--	UNION SELECT 2790,	34333,	1,	1,	1
--	UNION SELECT 2790,	34333,	1,	2,	2
--	UNION SELECT 2790,	34333,	1,	3,	4
--	UNION SELECT 2790,	34333,	1,	5,	2
--	UNION SELECT 2790,	34333,	1,	4,	2
--	UNION SELECT 2790,	34333,	5,	1,	3
--	UNION SELECT 2790,	34333,	5,	2,	4
--	UNION SELECT 2790,	34333,	5,	3,	4
--	UNION SELECT 2790,	34333,	5,	5,	3
--	UNION SELECT 2790,	34333,	5,	4,	1
--	UNION SELECT 2790,	34333,	6,	1,	3
--	UNION SELECT 2790,	34333,	6,	2,	3
--	UNION SELECT 2790,	34333,	6,	3,	4
--	UNION SELECT 2790,	34333,	6,	5,	3
--	UNION SELECT 2790,	34333,	6,	4,	4
--	UNION SELECT 2790,	34764,	1,	1,	2
--	UNION SELECT 2790,	34764,	1,	2,	3
--	UNION SELECT 2790,	34764,	1,	3,	3
--	UNION SELECT 2790,	34764,	1,	5,	2
--	UNION SELECT 2790,	34764,	1,	4,	4
--	UNION SELECT 2790,	34764,	5,	1,	3
--	UNION SELECT 2790,	34764,	5,	2,	3
--	UNION SELECT 2790,	34764,	5,	3,	4
--	UNION SELECT 2790,	34764,	5,	5,	3
--	UNION SELECT 2790,	34764,	5,	4,	4
--	UNION SELECT 2790,	34764,	6,	1,	3
--	UNION SELECT 2790,	34764,	6,	2,	4
--	UNION SELECT 2790,	34764,	6,	3,	4
--	UNION SELECT 2790,	34764,	6,	5,	3
--	UNION SELECT 2790,	34764,	6,	4,	4
--	UNION SELECT 2738,	33826,	1,	1,	1
--	UNION SELECT 2738,	33826,	1,	2,	2
--	UNION SELECT 2738,	33826,	1,	3,	2
--	UNION SELECT 2738,	33826,	1,	4,	1
--	UNION SELECT 2738,	33826,	1,	5,	2
--	UNION SELECT 2738,	33826,	5,	1,	2
--	UNION SELECT 2738,	33836,	5,	2,	3
--	UNION SELECT 2738,	33836,	5,	3,	2
--	UNION SELECT 2738,	33836,	5,	4,	1
--	UNION SELECT 2738,	33836,	5,	5,	3
--	UNION SELECT 2738,	34333,	1,	1,	2
--	UNION SELECT 2738,	34333,	1,	2,	1
--	UNION SELECT 2738,	34333,	1,	3,	2
--	UNION SELECT 2738,	34333,	1,	4,	1
--	UNION SELECT 2738,	34333,	1,	5,	1
--	UNION SELECT 2738,	34333,	5,	1,	4
--	UNION SELECT 2738,	34333,	5,	2,	3
--	UNION SELECT 2738,	34333,	5,	3,	2
--	UNION SELECT 2738,	34333,	5,	4,	2
--	UNION SELECT 2738,	34333,	5,	5,	3

--END
--GO


















